<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0051)http://technet.microsoft.com/zh-cn/library/ms191294 -->
<html xmlns="http://www.w3.org/1999/xhtml"><head id="ctl00_Head1"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><link rel="canonical" href="http://technet.microsoft.com/zh-cn/library/ms191294.aspx"><title>
	
  启用或禁用服务器网络协议

</title>






<meta name="DCS.dcsuri" content="/zh-cn/library/ms191294(d=lightweight,l=zh-cn,v=sql.110).aspx">

<meta name="NormalizedUrl" content="http://technet.microsoft.com/zh-cn/library/ms191294(d=lightweight,l=zh-cn,v=sql.110).aspx">

<meta name="VotingContextUrl" content="http://technet.microsoft.com/zh-cn/library/ms191294(l=zh-cn,v=sql.110).aspx">

<meta name="MN" content="7AE95E64-6:22:26 AM">

<meta name="Search.ShortId" content="ms191294">

<meta name="Ms.Locale" content="zh-cn">
<link rel="stylesheet" type="text/css" href="./启用或禁用服务器网络协议(Ch)_files/Combined.css" xmlns="http://www.w3.org/1999/xhtml"><link rel="stylesheet" type="text/css" href="./启用或禁用服务器网络协议(Ch)_files/printview.css" media="print" title="printonly"><link rel="alternate" media="print" href="http://technet.microsoft.com/zh-cn/library/ms191294(d=printer)"><script type="text/javascript" async="" src="./启用或禁用服务器网络协议(Ch)_files/ms2.js"></script><script src="./启用或禁用服务器网络协议(Ch)_files/broker.js"></script></head>
<body>
    
        
        
        
        
        

    <div class="header cl_header">
        





	
<div id="megabladeContainer" xmlns="http://www.w3.org/1999/xhtml">
    <div id="megabladeContainerCenter">
        <ul id="megabladeItems">
					<li class="Logo"><a href="http://technet.microsoft.com/" title="TechNet">TechNet</a></li>
								<li data-value="hh326172" class="bladeItem bladeItemWithMenu">
									<a class="label" href="" onclick="return false;">
										产品
									</a>
								<span class="caret"></span></li>
								<li data-value="hh880860" class="bladeItem bladeItemWithMenu">
									<a class="label" href="" onclick="return false;">
										资源
									</a>
								<span class="caret"></span></li>
								<li data-value="hh371326" class="bladeItem bladeItemWithMenu">
									<a class="label" href="" onclick="return false;">
										下载
									</a>
								<span class="caret"></span></li>
								<li data-value="hh371327" class="bladeItem bladeItemWithMenu">
									<a class="label" href="" onclick="return false;">
										支持
									</a>
								<span class="caret"></span></li>
        </ul>
        <div class="bladeItemMenuContainer">
            <div data-value="hh326172" class="bladeItemMenu" style="display:none;">
            <div class="menuContainerLayout">
  <h5>产品</h5>
  <ul>
    <li style="min-height:50px;width:176px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/windows">
        <img alt="" height="435" style="left:0;top:0;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 16px 0 16px 6px;vertical-align:top;" href="http://technet.microsoft.com/windows">Windows</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/windowsserver">
        <img alt="" height="435" style="left:0;top:0;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 7px 0 7px 6px;vertical-align:top;" href="http://technet.microsoft.com/windowsserver">Windows<br>Server</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/systemcenter">
        <img alt="" height="435" style="left:0;top:-275px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 7px 0 7px 6px;vertical-align:top;" href="http://technet.microsoft.com/systemcenter">System<br>Center</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/ie">
        <img alt="" height="435" style="left:0;top:-330px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 7px 0 7px 6px;vertical-align:top;" href="http://technet.microsoft.com/ie">Internet<br>Explorer</a>
    </li>
  </ul>
</div><div class="menuContainerLayout">
  <h5>&nbsp;</h5>
  <ul>
    <li style="min-height:50px;width:176px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/office">
        <img alt="" height="435" style="left:0;top:-110px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 16px 0 16px 6px;vertical-align:top;" href="http://technet.microsoft.com/office">Office</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/office365">
        <img alt="" height="435" style="left:0;top:-110px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 16px 0 16px 6px;vertical-align:top;" href="http://technet.microsoft.com/office365">Office 365</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/exchange">
        <img alt="" height="435" style="left:0;top:-55px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 7px 0 7px 6px;vertical-align:top;" href="http://technet.microsoft.com/exchange">Exchange<br>Server</a>
    </li>
  </ul>
</div><div class="menuContainerLayout">
  <h5>&nbsp;</h5>
  <ul>
    <li style="min-height:50px;width:176px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/sql">
        <img alt="" height="435" style="left:0;top:-220px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 16px 0 16px 6px;vertical-align:top;" href="http://technet.microsoft.com/sql">SQL Server</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/sharepoint">
        <img alt="" height="435" style="left:0;top:-165px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 7px 0 7px 6px;vertical-align:top;" href="http://technet.microsoft.com/sharepoint">SharePoint<br>产品</a>
    </li>
    <li style="min-height:50px;width:176px;padding-top:10px;">
      <a style="height:50px;width:50px;position:relative;overflow:hidden;display:inline-block;background:#ccc;" href="http://technet.microsoft.com/lync">
        <img alt="" height="435" style="left:0;top:-165px;position:relative;" width="50" src="./启用或禁用服务器网络协议(Ch)_files/hh326172.productLogoSprite_transparent(zh-cn,MSDN.10).png">
      </a>
      <a style="display:inline-block;width:auto;padding: 16px 0 16px 6px;vertical-align:top;" href="http://technet.microsoft.com/lync">Lync</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/bb421517.aspx?wt.svl=more_centers_link">查看所有产品 »</a>
    </li>
  </ul>
</div>
            </div>
            <div data-value="hh880860" class="bladeItemMenu" style="display:none;">
            <div class="menuContainerLayout">
  <h5>资源</h5>
  <ul>
    <li>
      <a href="http://technet.microsoft.com/scriptcenter">脚本中心</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/solutionaccelerators">解决方案加速器</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/sysinternals">Windows Sysinternals</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter">评估中心</a>
    </li>
    <li>
      <a href="http://answers.microsoft.com/">Microsoft Answers</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/edge">TechNet Edge</a>
    </li>
  </ul>
</div><div class="menuContainerLayout">
  <h5>&nbsp;</h5>
  <ul>
    <li>
      <a href="http://technet.microsoft.com/cc543196">TechNet 中文速递邮件</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/magazine">TechNet 杂志</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/subscriptions">TechNet 订阅</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/virtuallabs">虚拟实验室</a>
    </li>
  </ul>
</div><div class="menuContainerLayoutSplashGuard"></div><div class="menuContainerLayout">
  <h5>解决方案</h5>
  <ul>
    <li>
      <a href="http://technet.microsoft.com/bi">商业智能</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/network">网络</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/private-cloud">私有云</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/security">安全性</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/virtualization">虚拟化</a>
    </li>
  </ul>
</div>
            </div>
            <div data-value="hh371326" class="bladeItemMenu" style="display:none;">
            <div class="menuContainerLayout">
  <h5>下载</h5>
  <ul>
    <li>
      <a href="http://technet.microsoft.com/windows/hh771457.aspx?ocid=wc-tn-mgbld">Windows 8 Consumer Preview</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/windows/gg635126">适用于 Windows Server 2008 R2 和 Windows 7 的 SP1 RTM</a>
    </li>
    <li>
      <a href="http://windows.microsoft.com/zh-cn/internet-explorer/downloads/ie-9/worldwide-languages">Internet Explorer 9</a>
    </li>
    <li>
      <a href="http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx">SQL Server 2012</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/bb403698">查看所有下载 »</a>
    </li>
  </ul>
</div><div class="menuContainerLayoutSplashGuard"></div><div class="menuContainerLayout">
  <h5>评估</h5>
  <ul>
    <li>
      <a href="http://www.microsoft.com/click/services/Redirect2.ashx?CR_CC=200103322">Microsoft Private Cloud</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter/hh670538">Windows Server "8" Beta 试用版</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter/ee390818">Office Professional Plus 2010</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter/cc442495">Windows 7 企业版试用版</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter/ee404758">Project Professional 2010</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter/dd459137.aspx">Windows Server 2008 R2 SP1</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/evalcenter/bb291020">查看所有评估 »</a>
    </li>
  </ul>
</div><div class="menuContainerLayoutSplashGuard"></div><div class="menuContainerLayout">
  <h5>Tools</h5>
  <ul>
    <li>
      <a href="http://support.microsoft.com/default.aspx?id=fh;zh-cn;sp&fr=0&sd=gn&ln=zh-cn&ct=sd&se=nona">Service Pack</a>
    </li>
    <li>
      <a href="http://gallery.technet.microsoft.com/scriptcenter">TechNet 脚本中心</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/security/cc297183">安全工具</a>
    </li>
    <li>
      <span style="”white=space:nowrap">
        <a href="http://www.microsoft.com/downloads/search.aspx">Microsoft 下载中心</a>
      </span>
    </li>
  </ul>
</div>
            </div>
            <div data-value="hh371327" class="bladeItemMenu" style="display:none;">
            <div class="menuContainerLayout">
  <h5>TechNet 支持</h5>
  <ul>
    <li>
      <a href="http://technet.microsoft.com/exchange/ff396001.aspx">Exchange Server 2010</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/forefront/ff404202">Forefront 产品</a>
    </li>
    <li>
      <a href="http://support.microsoft.com/ph/807#tab0">Internet Explorer 9</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/office/ee263916">Office 2010</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/sharepoint/ee410533">SharePoint Server 2010</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/sqlserver/ff472320">SQL Server 2008 R2</a>
    </li>
  </ul>
</div><div class="menuContainerLayout">
  <h5>&nbsp;</h5>
  <ul>
    <li>
      <a href="http://technet.microsoft.com/windows/bb187457">Windows 7</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/systemcenter/cc511006">System Center</a>
    </li>
    <li>
      <a href="http://technet.microsoft.com/windowsserver/bb512923">Windows Server 2008 R2</a>
    </li>
    <li>
      <a href="http://social.technet.microsoft.com/Forums/categories">在 TechNet 论坛中询问问题</a>
    </li>
  </ul>
</div><div class="menuContainerLayoutSplashGuard"></div><div class="menuContainerLayout">
  <h5>Microsoft 支持</h5>
  <ul>
    <li>
      <a href="http://support.microsoft.com/">Microsoft 支持</a>
    </li>
    <li>
      <a href="http://support.microsoft.com/fixit/">Microsoft Fix It</a>
    </li>
    <li>
      <a href="http://www.microsoft.com/services/microsoftservices/busi.mspx">Microsoft 高级和基本支持选项</a>
    </li>
  </ul>
</div>
            </div>
        </div>
    </div>
</div>
<script type="text/javascript" xmlns="http://www.w3.org/1999/xhtml">
        var omnitureTracking = true;
    </script>



<div id="tn_isd_header" class="sqlserver">
    <div class="upperBand">
        <a href="http://technet.microsoft.com/zh-cn/sqlserver/bb265254" title="SQL Server"><img src="./启用或禁用服务器网络协议(Ch)_files/BrandLogoSqlserver.png" alt="SQL Server"></a>
        <div class="searchBox">
            
<form id="SearchForm" action="http://social.technet.microsoft.com/search/zh-cn" method="get" style="margin: 0; padding: 0;" onsubmit="return checkSearchBox()">
<div class="searchBoxContainer" style="">
  <table class="searchBox" cellpadding="0" cellspacing="0" border="0">
    <tbody><tr>
      <td class="searchTextBoxTd">
        <input id="SearchInput" type="text" maxlength="200" class="searchTextBox" name="query">
        <input name="refinement" type="hidden" value="30">
      </td>
      <td class="searchButtonTd">
          <input type="image" src="./启用或禁用服务器网络协议(Ch)_files/search_icon.gif" style="position: relative;" title="搜索 ">
      </td>
    </tr>
  </tbody></table>
</div>
</form>
<script type="text/javascript">
//<![CDATA[
    if (!MTPS) var MTPS = {};
    if (!MTPS.Watermarks) MTPS.Watermarks = {};
    MTPS.Watermarks.SearchInput = {
        "control": "SearchInput",
        "defaultValue": "使用 Bing 搜索 SQL Server",
        "defaultCSS": "searchTextBox",
        "focusCSS": "searchTextBoxTrue"
    };
    function checkSearchBox() {
        if (document.getElementById("SearchInput").value == MTPS.Watermarks.SearchInput.defaultValue) {
            document.getElementById("SearchInput").value = "";
        }
    }
 //]]>
</script>


        </div>
        <div class="upperRight">
            <div>
                <a class="locale" href="http://technet.microsoft.com/zh-cn/library/preferences/locale/?returnurl=%252fzh-cn%252flibrary%252fms191294" title="中国（简体中文）">中国（简体中文）</a>
                <a class="signIn" href="https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&ct=1337952146&rver=6.0.5276.0&wp=MCLBI&wlcxt=technet%24technet%24technet&wreply=http%3a%2f%2ftechnet.microsoft.com%2fzh-cn%2flibrary%2fms191294&lc=2052&id=254354&mkt=zh-CN" title=" 登录  "> 登录  </a>
            </div>
            
        </div>
    </div>
    <div class="lowerBand">
        
        <div class="tabContainer">
            <div class="tab">
                <a href="http://technet.microsoft.com/zh-cn/sqlserver/bb265254" title="主页" class="">主页</a>
            </div>
        </div>

        <div class="tabContainer">
            <div class="tabSelected tabSelectedImage">
                <a href="http://technet.microsoft.com/zh-cn/sqlserver/ff398089" title="2008 R2" class="">2008 R2</a>
            </div>
        </div>

        <div class="tabContainer">
            <div class="tab">
                <a href="http://technet.microsoft.com/zh-cn/sqlserver/bb671410" title="2008" class="">2008</a>
            </div>
        </div>

        <div class="tabContainer">
            <div class="tab">
                <a href="http://technet.microsoft.com/zh-cn/sqlserver/bb671245" title="2005" class="">2005</a>
            </div>
        </div>

        <div class="tabContainer">
            <div class="tab">
                <a href="http://technet.microsoft.com/library/bb545450.aspx" title="技术资源库" class="">技术资源库</a>
            </div>
        </div>

        <div class="tabContainer">
            <div class="tab">
                <a href="http://social.technet.microsoft.com/Forums/zh-cn/category/sqlserver" title="论坛" class="">论坛</a>
            </div>
        </div>

            <div class="menus">
                <a id="isd_settings" class="isd_settings" href="http://technet.microsoft.com/zh-cn/library/preferences/experience/?returnurl=%252fzh-cn%252flibrary%252fms191294" title="首选项" rel="nofollow"></a>
                <a id="isd_print" class="isd_print_arrow" href="http://technet.microsoft.com/zh-cn/library/ms191294(d=printer)" title="打印/导出" rel="nofollow"></a>
                
                    <div id="isd_print_menu" class="isd_menu">
                        <a href="http://technet.microsoft.com/zh-cn/library/ms191294(d=printer)">打印此主题</a>
                        <a href="http://technet.microsoft.com/zh-cn/library/export/help/?returnurl=%2fzh-cn%2flibrary%2fms191294">打印多个主题</a>
                    </div>
                
            </div>
        
    </div>
</div>

    </div>
    
<div id="exportTiny" class="exportTinyContent" style="display: none;">
  <a id="printThisTopicLink" href="http://technet.microsoft.com/zh-cn/library/ms191294(d=printer)" title="打印此主题">
    打印此主题</a>
  <br>
  <a id="printMultipleTopicsLink" href="http://technet.microsoft.com/zh-cn/library/export/help/?returnurl=%2fzh-cn%2flibrary%2fms191294" title="打印多个主题">
    打印多个主题</a>
</div>

<script type="text/javascript">
//<![CDATA[
  if (!MTPS) var MTPS = {};
  if (!MTPS.ExportValues) MTPS.ExportValues = {};
  MTPS.ExportValues.PrintMultipleUrl = "/zh-cn/library/export/print/?returnurl=%252fzh-cn%252flibrary%252fms191294";
  MTPS.ExportValues.PrintHelpUrl = "/zh-cn/library/export/help/?returnurl=%2fzh-cn%2flibrary%2fms191294";
 //]]>
</script>


    <div class="contentPlaceHolder">
        
    
  <div class="navigation" id="Navigation" style="padding-bottom: 96px; width: 0px; display: none; ">
    <div class="searchcontainer">
      
    </div>
    <div class="navcontainer">
      
<div class="nav">



<div id="tocnav">
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/aa991542" id="bb126093_TechNet.10_zh-cn" title="TechNet 库">TechNet 库</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/bb418431(v=sql.10)" id="bb418431_SQL.10_zh-cn" title="SQL Server">SQL Server</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/bb418432(v=sql.10)" id="bb418432_SQL.10_zh-cn" title="SQL Server 2012">SQL Server 2012</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/bb418433(v=sql.10)" id="bb418433_SQL.10_zh-cn" title="产品文档">产品文档</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/ms130214" id="ee679654_SQL.110_zh-cn" title="SQL Server 2012 联机丛书">SQL Server 2012 联机丛书</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/ms187875" id="ee679659_SQL.110_zh-cn" title="数据库引擎">数据库引擎</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/bb500155" id="ee679662_SQL.110_zh-cn" title="数据库引擎功能和任务">数据库引擎功能和任务</a>
            </div>
            <div class="toclevel0" data-toclevel="0" style="padding-left: 0px; ">
                <a class="toc_collapsed" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/hh231298" id="hh257165_SQL.110_zh-cn" title="数据库引擎实例">数据库引擎实例</a>
            </div>
            <div class="toclevel1" data-toclevel="1" style="padding-left: 13px; " data-childrenloaded="true">
                <a class="toc_expanded" href="http://technet.microsoft.com/zh-cn/library/ms191294#"></a><a data-tochassubtree="true" href="http://technet.microsoft.com/zh-cn/library/ms189083" id="hh257246_SQL.110_zh-cn" title="服务器网络配置">服务器网络配置</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/dd207004" title="在系统管理员被锁定时连接到 SQL Server">在系统管理员被锁定时连接到 SQL Server</a>
            </div>
            <div class="toclevel2 current" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="./启用或禁用服务器网络协议(Ch)_files/启用或禁用服务器网络协议(Ch).htm" title="启用或禁用服务器网络协议">启用或禁用服务器网络协议</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms177440" title="配置服务器以侦听特定 TCP 端口（SQL Server 配置管理器）">配置服务器以侦听特定 TCP 端口（SQL Server 配置管理器）</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms189321" title="配置服务器以侦听备用管道（SQL Server 配置管理器）">配置服务器以侦听备用管道（SQL Server 配置管理器）</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms191192" title="启用数据库引擎的加密连接（SQL Server 配置管理器）">启用数据库引擎的加密连接（SQL Server 配置管理器）</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms179448" title="通过代理服务器连接到 SQL Server（SQL Server 配置管理器）">通过代理服务器连接到 SQL Server（SQL Server 配置管理器）</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms175043" title="为数据库引擎访问配置 Windows 防火墙">为数据库引擎访问配置 Windows 防火墙</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms179327" title="隐藏 SQL Server 数据库引擎的实例">隐藏 SQL Server 数据库引擎的实例</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms189310" title="将数据库引擎配置为侦听多个 TCP 端口">将数据库引擎配置为侦听多个 TCP 端口</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms366339" title="确定是否已安装并启动数据库引擎">确定是否已安装并启动数据库引擎</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ff487261" title="使用扩展保护连接到数据库引擎">使用扩展保护连接到数据库引擎</a>
            </div>
            <div class="toclevel2" data-toclevel="2" style="padding-left: 26px; ">
                <span class="toc_empty"></span><a href="http://technet.microsoft.com/zh-cn/library/ms191153" title="为 Kerberos 连接注册服务主体名称">为 Kerberos 连接注册服务主体名称</a>
            </div>
</div>    



<div class="communityContentNavigation">
    <div class="communityContentNavigationHeader">
        社区内容
    </div>
        <div class="communityContentNavigationPost">
            <div class="communityContentNavigationAvatarContainer">
                <a class="communityContentNavigationLinkAvatar" href="http://technet.microsoft.com/zh-cn/library/ms191294#CommunityContent" title="用户"><img alt="头像" class="cl_default_avatar" src="./启用或禁用服务器网络协议(Ch)_files/clear.gif"></a>
            </div>
                <div class="communityContentNavigationLinkAbstractAdvertisement">
                    <ul>
                        <li>添加代码示例和提示以增强此主题。</li>
                    </ul>
                </div>
        </div>
    <div class="communityContentNavigationMoreLink">
        <a href="http://technet.microsoft.com/zh-cn/library/ms191294#CommunityContent" title="更多...">更多...</a>
    </div>
</div>
    
</div>


<script type="text/javascript"> 
    //<![CDATA[
    if (!MTPS) var MTPS = {};
    MTPS.TopicNodes = {
        'last' : ''
    }
    //]]>
</script>

    </div>
    
  </div>
  <div id="tocResizeContainer" style="visibility: visible; ">
  <a href="javascript:void(0)" class="tocResize" id="TocResize" style="left: 0px; ">
    <img id="ResizeImageIncrease" class="cl_nav_resize_open" src="./启用或禁用服务器网络协议(Ch)_files/LibrarySprite.png" title="展开" alt="展开" style="">
      <img id="ResizeImageReset" class="cl_nav_resize_close" src="./启用或禁用服务器网络协议(Ch)_files/LibrarySprite.png" style="display: none; " title="最小化" alt="最小化">
  </a>
  </div>
  <div class="content">
    
    
<script src="./启用或禁用服务器网络协议(Ch)_files/jquery-1.7.1.min.js" type="text/javascript" data-do-not-move="true"></script>
<div id="MTPSTranslator" class="MTPSTranslator">
  <table class="MTPSTranslatorTable" style="width:100%">
    <tbody><tr>
      <td class="TranslationAlertBox"><div>此文章由人工翻译。 将光标移到文章的句子上，以查看原文。 </div></td>
      
      <td class="TranslationViewSwitcher">
        <div>
          <input title="显示译文" value="0" name="TrnaslatorView" type="radio" class="translatechoice" checked="checked"><span>译文</span>
        </div>
        <div>
          <input title="显示英文" value="1" name="TrnaslatorView" type="radio" class="translatechoice"><span>原文</span>
        </div>
      </td>
      
    </tr>
  </tbody></table>
</div>

    <script type="text/javascript">
    //<![CDATA[
    if (!MTPS) var MTPS = {};
    if (!MTPS.Translation) MTPS.Translation = {};
    MTPS.Translation.TranslationType =   0 ;
    
  //]]>
</script>

 
 
  

    <div class="topicContainer">
        







    

<div class="topic" xmlns="http://www.w3.org/1999/xhtml">
  <h1 class="title">启用或禁用服务器网络协议</h1>
  <div class="lw_vs">
    <div id="curversion">
      <strong>
            SQL Server 2012</strong>
    </div>
    <div id="versionclick" style="visibility: visible; ">
      <div id="vsseperator" class="cl_lw_vs_seperator"></div>
      <div id="versionclick_c1"></div>
      <div id="versionclick_c2">
        <div class="">
          <a id="vsLink" href="javascript:;">
                    其他版本
                </a>
        </div>
        <div class="cl_vs_arrow clip10x10">
          <img class="cl_lw_vs_arrow" id="vsArrow" alt="" src="./启用或禁用服务器网络协议(Ch)_files/LibrarySprite.png">
        </div>
      </div>
      <div id="versionclick_c3"></div>
    </div>
    <ul id="vsPanel">
      <li>
        <a href="http://technet.microsoft.com/zh-cn/library/ms191294(v=sql.105)" title="">SQL Server 2008 R2</a>
      </li>
      <li>
        <a href="http://technet.microsoft.com/zh-cn/library/ms191294(v=sql.100)" title="">SQL Server 2008</a>
      </li>
      <li>
        <a href="http://technet.microsoft.com/zh-cn/library/ms191294(v=sql.90)" title="">SQL Server 2005</a>
      </li>
    </ul>
  <div id="ratingCounterSeperator" class="cl_lw_vs_seperator" style="visibility: visible; "></div><div id="ratingCounter" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 13px; display: block; ">

        <span id="rcA" class="ratingText">
            此主题尚未评级 <span id="rateThisPrefix">- </span><a id="rateThisTopic" href="http://technet.microsoft.com/zh-cn/library/ms191294#feedback" title="评价此主题">评价此主题</a>
            
        </span>
    </div></div>
  <div style="clear:both;"></div>
  
  <div id="mainSection">
    <div id="mainBody">
      <a id="Intro">
        
      </a>
      <div class="introduction">
        <p>
          <span id="mt1" class="sentence" data-guid="bbd0d8fc23c2e4bcc2abf0a45992b058" data-source="All network protocols are installed by SQL Server Setup, but may or may not be enabled.">所有网络协议都是由 SQL Server 安装程序安装的，可以启用也可以禁用这些网络协议。</span>  <span id="mt2" class="sentence" data-guid="1a0a2c5c4479ce32da3523e49de268ff" data-source="This topic describes how to enable or disable a server network protocol in SQL Server 2012 by using SQL Server Configuration Manager or PowerShell.">本主题介绍如何通过使用 SQL Server 配置管理器或 PowerShell，在 SQL Server 2012 中启用或禁用服务器网络协议。</span>  <span id="mt3" class="sentence" data-guid="e38473194fc2d1cec0890604e4056b98" data-source="The Database Engine must be stopped and restarted for the change to take effect.">必须停止并重新启动数据库引擎，更改才能生效。</span>  </p>
        <div class="alert">
          <table>
            <tbody><tr>
              <th>
                
                <img id="alert_security" alt="安全说明" src="./启用或禁用服务器网络协议(Ch)_files/IC101171.gif" title="安全说明" xmlns="">
                <strong>安全说明</strong>
              </th>
            </tr>
            <tr>
              <td>
                <p>
                  <span id="mt4" class="sentence" data-guid="5639ee05b695b693fdb7b719b72eb9ba" data-source="During setup of SQL Server Express a login is added for the BUILTIN\Users group.">在安装 SQL Server Express 过程中，将为 BUILTIN\Users 组添加一个登录名。</span>  <span id="mt5" class="sentence" data-guid="77bbd6c9f5bd6b5c60bc9ef89a9ca002" data-source="This allows all authenticated users of the computer to access the instance of SQL Server Express as a member of the public role.">这使得计算机的所有通过身份验证的用户能够作为 public 角色的成员访问 SQL Server Express 实例。</span>  <span id="mt6" class="sentence" data-guid="ec5a4bb36f65c1f7a19f68db65511bfc" data-source="The BUILTIN\Users login can be safely removed to restrict Database Engine access to computer users who have individual logins or are members of other Windows groups with logins.">可以安全地删除 BUILTIN\Users 登录名，以便将数据库引擎访问限制为具有单独登录名的计算机用户或具有登录名的其他 Windows 组成员的计算机用户。</span>  </p>
              </td>
            </tr>
          </tbody></table>
        </div>
      </div>
      <div id="sectionSection0" class="seeAlsoNoToggleSection">
        <p>
          <span class="label">本主题内容</span>
        </p>
        <ul>
          <li>
            <p>
              <span class="label">使用以下工具启用或禁用服务器网络协议：</span>
            </p>
            <p>
              <a href="http://technet.microsoft.com/zh-cn/library/ms191294#SSMSProcedure">SQL Server 配置管理器</a>
            </p>
            <p>
              <a href="http://technet.microsoft.com/zh-cn/library/ms191294#PowerShellProcedure">PowerShell</a>
            </p>
          </li>
        </ul>
      </div>
      <a id="SSMSProcedure">
        
      </a>
      <div xmlns="">
        <script type="text/javascript">if (!MTPS) var MTPS = {};if (!MTPS.LocalizedStrings) MTPS.LocalizedStrings = {}; MTPS.LocalizedStrings.ExpandButtonTooltip = '展开'; MTPS.LocalizedStrings.CollapseButtonTooltip = '折叠';</script>
        <div class="LW_CollapsibleArea_TitleDiv">
          <div>
            <a href="javascript:void(0)" class="LW_CollapsibleArea_TitleAhref" title="折叠">
              <img src="./启用或禁用服务器网络协议(Ch)_files/clear.gif" class="cl_CollapsibleArea_expanding LW_CollapsibleArea_Img">
              <span class="LW_CollapsibleArea_Title">使用 SQL Server 配置管理器</span>
            </a>
            <div class="LW_CollapsibleArea_HrDiv">
              <hr class="LW_CollapsibleArea_Hr">
            </div>
          </div>
        </div>
        <div class="sectionblock">
          <a id="sectionToggle1" xmlns="http://www.w3.org/1999/xhtml">
  
</a>
<h3 class="procedureSubHeading" xmlns="http://www.w3.org/1999/xhtml">启用服务器网络协议</h3>
<div class="subSection" xmlns="http://www.w3.org/1999/xhtml">
  <ol>
    <li>
      <p>
        <span id="mt9" class="sentence" data-guid="fa0a54a2840d663b75514edc6323ce47" data-source="In SQL Server Configuration Manager, in the console pane, expand &lt;span class=&quot;label&quot;&gt;SQL Server  Network Configuration&lt;/span&gt;.">在 SQL Server 配置管理器的控制台窗格中，展开<span class="label" xmlns="http://www.w3.org/1999/xhtml">“SQL Server 网络配置”</span>。</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt10" class="sentence" data-guid="3e8eb278a16c4304eac71fa7ca97637d" data-source="In the console pane, click &lt;span class=&quot;label&quot;&gt;Protocols for &lt;/span&gt;&lt;span class=&quot;parameter&quot;&gt;&amp;lt;instance name&amp;gt;&lt;/span&gt;.">在控制台窗格中，单击<span class="label" xmlns="http://www.w3.org/1999/xhtml">“&lt;instance name&gt; 的协议”</span>。</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt11" class="sentence" data-guid="8fa3ae8ee89a50f672ad048bb830852d" data-source="In the details pane, right-click the protocol you want to change, and then click &lt;span class=&quot;label&quot;&gt;Enable&lt;/span&gt; or &lt;span class=&quot;label&quot;&gt;Disable&lt;/span&gt;.">在细节窗格中，右键单击要更改的协议，再单击<span class="label" xmlns="http://www.w3.org/1999/xhtml">“启用”</span>或<span class="label" xmlns="http://www.w3.org/1999/xhtml">“禁用”</span>。</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt12" class="sentence" data-guid="b643dbde20125d9faa3c6c94f0c9e7af" data-source="In the console pane, click &lt;span class=&quot;label&quot;&gt;SQL Server Services&lt;/span&gt;.">在控制台窗格中，单击<span class="label" xmlns="http://www.w3.org/1999/xhtml">“SQL Server 服务”</span>。</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt13" class="sentence" data-guid="0fe63a3341d6d26230c5d8b9d7041454" data-source="In the details pane, right-click &lt;span class=&quot;label&quot;&gt;SQL Server (&lt;/span&gt;&lt;span class=&quot;parameter&quot;&gt;&amp;lt;instance name&amp;gt;&lt;/span&gt;&lt;span class=&quot;label&quot;&gt;)&lt;/span&gt;, and then click &lt;span class=&quot;label&quot;&gt;Restart&lt;/span&gt;, to stop and restart the SQL Server service.">在详细信息窗格中，右键单击<span class="label" xmlns="http://www.w3.org/1999/xhtml">“SQL Server (</span><span class="parameter" xmlns="http://www.w3.org/1999/xhtml">&lt;instance name&gt;</span><span class="label" xmlns="http://www.w3.org/1999/xhtml">)”</span>，再单击<span class="label" xmlns="http://www.w3.org/1999/xhtml">“重新启动”</span>以停止并重新启动 SQL Server 服务。</span>
      </p>
    </li>
  </ol>
</div>
<p xmlns="http://www.w3.org/1999/xhtml">
  
  <img id="UpArrow16x16" alt="用于“返回首页”链接的箭头图标" src="./启用或禁用服务器网络协议(Ch)_files/IC169559.gif" title="用于“返回首页”链接的箭头图标" xmlns="">
  <span>
    <a href="http://technet.microsoft.com/zh-cn/library/ms191294#Intro">[Top]</a>
  </span>
</p></div>
      </div>
      <a id="PowerShellProcedure">
        
      </a>
      <div xmlns="">
        <div class="LW_CollapsibleArea_TitleDiv">
          <div>
            <a href="javascript:void(0)" class="LW_CollapsibleArea_TitleAhref" title="折叠">
              <img src="./启用或禁用服务器网络协议(Ch)_files/clear.gif" class="cl_CollapsibleArea_expanding LW_CollapsibleArea_Img">
              <span class="LW_CollapsibleArea_Title">使用 SQL Server PowerShell</span>
            </a>
            <div class="LW_CollapsibleArea_HrDiv">
              <hr class="LW_CollapsibleArea_Hr">
            </div>
          </div>
        </div>
        <div class="sectionblock">
          <a id="sectionToggle2" xmlns="http://www.w3.org/1999/xhtml">
  
</a>
<p xmlns="http://www.w3.org/1999/xhtml">
  
</p>
<h3 class="procedureSubHeading" xmlns="http://www.w3.org/1999/xhtml">使用 PowerShell 启用服务器网络协议</h3>
<div class="subSection" xmlns="http://www.w3.org/1999/xhtml">
  <ol>
    <li>
      <p>
        <span id="mt15" class="sentence" data-guid="0446cba353fa5d3ba1cda2c77c7377fb" data-source="Using administrator permissions open a command prompt.">使用管理员权限打开一个命令提示符。</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt16" class="sentence" data-guid="35bb06750cfb2e5e1702bc2faf6ea22f" data-source="Start Windows PowerShell 2.0 from the taskbar, or click Start, then All Programs, then Accessories, then Windows PowerShell, then Windows PowerShell.">可以从任务栏启动 Windows PowerShell 2.0，也可以通过依次单击“开始”、“所有程序”、“附件”、“Windows PowerShell”、“Windows PowerShell”来启动。</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt17" class="sentence" data-guid="1447c2141b38f5bb179df4869f089a86" data-source=" Import the &lt;strong&gt;sqlps&lt;/strong&gt; module by entering &lt;span class=&quot;input&quot;&gt;Import-Module “sqlps”&lt;/span&gt;"> 通过输入 <span class="input" xmlns="http://www.w3.org/1999/xhtml">Import-Module “sqlps”</span> 导入 <strong xmlns="http://www.w3.org/1999/xhtml">sqlps</strong> 模块</span>
      </p>
    </li>
    <li>
      <p>
        <span id="mt18" class="sentence" data-guid="5c962a148d88a6ec5663acfff1098c9a" data-source="Execute the following statements to enable both the TCP and named pipes protocols.">执行以下语句以启用 TCP 和 Named Pipes 协议。</span>  <span id="mt19" class="sentence" data-guid="a51aa3841739d1984264e8b9282e39f6" data-source="Replace &lt;span class=&quot;code&quot;&gt;&amp;lt;computer_name&amp;gt;&lt;/span&gt; with the name of the computer that is running SQL Server.">将 <span class="code" xmlns="http://www.w3.org/1999/xhtml">&lt;computer_name&gt;</span> 替换为运行 SQL Server 的计算机的名称。</span>  <span id="mt20" class="sentence" data-guid="b5ab3a8d5b94233a55db94b046c8f77e" data-source="If you are configuring a named instance, replace &lt;span class=&quot;code&quot;&gt;MSSQLSERVER&lt;/span&gt; with the instance name.">如果您在配置命名实例，请将 <span class="code" xmlns="http://www.w3.org/1999/xhtml">MSSQLSERVER</span> 替换为该实例的名称。</span>  </p>
      <p>
        <span id="mt21" class="sentence" data-guid="f6f439da3f733801b4f15261e04e9d85" data-source="To disable protocols, set the &lt;span class=&quot;code&quot;&gt;IsEnabled&lt;/span&gt; properties to &lt;span class=&quot;code&quot;&gt;$false&lt;/span&gt;.">若要禁用协议，请将 <span class="code" xmlns="http://www.w3.org/1999/xhtml">IsEnabled</span> 属性设置为 <span class="code" xmlns="http://www.w3.org/1999/xhtml">$false</span>。</span>
      </p>

<div class="codeSnippetContainer" xmlns="http://www.w3.org/1999/xhtml">
  
  
    <div class="codeSnippetContainerTabs">
        
    </div>
    <div class="codeSnippetContainerCodeContainer">
        <div class="codeSnippetToolBar">
            <div class="codeSnippetToolBarText">
                <a name="CodeSnippetCopyLink" title="复制到剪贴板。" href="javascript:CodeSnippet_CopyCode('CodeSnippetContainerCode_39581b5b-e182-4d90-b3f2-3ec5411269b8');">复制</a>
            </div>
        </div>
        <div id="CodeSnippetContainerCode_39581b5b-e182-4d90-b3f2-3ec5411269b8" class="codeSnippetContainerCode" dir="ltr">
            <div style="color:Black;"><pre>$smo = 'Microsoft.SqlServer.Management.Smo.'
$wmi = new-object ($smo + 'Wmi.ManagedComputer').

# List the object properties, including the instance names.
$Wmi

# Enable the TCP protocol on the default instance.
$uri = "ManagedComputer[@Name='&lt;computer_name&gt;']/ ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"
$Tcp = $wmi.GetSmoObject($uri)
$Tcp.IsEnabled = $true
$Tcp.Alter()
$Tcp

# Enable the named pipes protocol for the default instance.
$uri = "ManagedComputer[@Name='&lt;computer_name&gt;']/ ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Np']"
$Np = $wmi.GetSmoObject($uri)
$Np.IsEnabled = $true
$Np.Alter()
$Np
</pre></div>
            
        </div>
    </div>
</div>
</li>
  </ol>
</div>
<h3 class="procedureSubHeading" xmlns="http://www.w3.org/1999/xhtml">为本地计算机配置协议</h3>
<div class="subSection" xmlns="http://www.w3.org/1999/xhtml">
  <ul>
    <li>
      <p>
        <span id="mt22" class="sentence" data-guid="3a40b00e51b2922b8c09a3f1f14d56d7" data-source="When the script is run locally and configures the local computer, SQL Server PowerShell can make the script more flexible by dynamically determining the local computer name.">当脚本在本地运行并配置本地计算机时，SQL Server PowerShell 可以通过动态确定本地计算机的名称使脚本更为灵活。</span>  <span id="mt23" class="sentence" data-guid="a949d501ac5727286de6dcc4b2022039" data-source="To retrieve the local computer name, replace the line setting the &lt;span class=&quot;code&quot;&gt;$uri&lt;/span&gt; variable with the following line.">若要检索本地计算机的名称，请将设置 <span class="code" xmlns="http://www.w3.org/1999/xhtml">$uri</span> 变量的行替换为以下行。</span>  </p>

<div class="codeSnippetContainer" xmlns="http://www.w3.org/1999/xhtml">
  
  
    <div class="codeSnippetContainerTabs">
        
    </div>
    <div class="codeSnippetContainerCodeContainer">
        <div class="codeSnippetToolBar">
            <div class="codeSnippetToolBarText">
                <a name="CodeSnippetCopyLink" title="复制到剪贴板。" href="javascript:CodeSnippet_CopyCode('CodeSnippetContainerCode_bc259edd-02bc-44ab-9260-3af981961262');">复制</a>
            </div>
        </div>
        <div id="CodeSnippetContainerCode_bc259edd-02bc-44ab-9260-3af981961262" class="codeSnippetContainerCode" dir="ltr">
            <div style="color:Black;"><pre>$uri = "ManagedComputer[@Name='" + (get-item env:\computername).Value + "']/ServerInstance[@Name='MSSQLSERVER']/ServerProtocol[@Name='Tcp']"
</pre></div>
            
        </div>
    </div>
</div>
</li>
  </ul>
</div>
<h3 class="procedureSubHeading" xmlns="http://www.w3.org/1999/xhtml">使用 SQL Server PowerShell 重新启动数据库引擎</h3>
<div class="subSection" xmlns="http://www.w3.org/1999/xhtml">
  <ul>
    <li>
      <p>
        <span id="mt24" class="sentence" data-guid="b47d9f8f74c416b42666dfcfef496ef3" data-source="After you enable or disable protocols, you must stop and restart the Database Engine for the change to take effect.">启用或禁用了协议后，必须停止并重新启动数据库引擎才能使更改生效。</span>  <span id="mt25" class="sentence" data-guid="37b7ac89b1cb5b57609985cdfdc8858c" data-source="Execute the following statements to stop and start the default instance by using SQL Server PowerShell.">执行以下语句，通过使用 SQL Server PowerShell 来停止和启动默认实例。</span>  <span id="mt26" class="sentence" data-guid="6ba6f98108f9600e3d1b21af003ed9f4" data-source="To stop and start a named instance replace &lt;span class=&quot;code&quot;&gt;&#39;MSSQLSERVER&#39;&lt;/span&gt; with &lt;span class=&quot;code&quot;&gt;&#39;MSSQL$&amp;lt;instance_name&amp;gt;&#39;&lt;/span&gt;.">若要停止和启动命名实例，请将 <span class="code" xmlns="http://www.w3.org/1999/xhtml">'MSSQLSERVER'</span> 替换为 <span class="code" xmlns="http://www.w3.org/1999/xhtml">'MSSQL$&lt;instance_name&gt;'</span>。</span>  </p>

<div class="codeSnippetContainer" xmlns="http://www.w3.org/1999/xhtml">
  
  
    <div class="codeSnippetContainerTabs">
        
    </div>
    <div class="codeSnippetContainerCodeContainer">
        <div class="codeSnippetToolBar">
            <div class="codeSnippetToolBarText">
                <a name="CodeSnippetCopyLink" title="复制到剪贴板。" href="javascript:CodeSnippet_CopyCode('CodeSnippetContainerCode_6e39635c-0adf-4f9d-9f78-912d6a3bcf84');">复制</a>
            </div>
        </div>
        <div id="CodeSnippetContainerCode_6e39635c-0adf-4f9d-9f78-912d6a3bcf84" class="codeSnippetContainerCode" dir="ltr">
            <div style="color:Black;"><pre># Get a reference to the ManagedComputer class.
CD SQLSERVER:\SQL\&lt;computer_name&gt;
$Wmi = (get-item .).ManagedComputer
# Get a reference to the default instance of the Database Engine.
$DfltInstance = $Wmi.Services['MSSQLSERVER']
# Display the state of the service.
$DfltInstance
# Stop the service.
$DfltInstance.Stop();
# Wait until the service has time to stop.
# Refresh the cache.
$DfltInstance.Refresh(); 
# Display the state of the service.
$DfltInstance
# Start the service again.
$DfltInstance.Start();
# Wait until the service has time to start.
# Refresh the cache and display the state of the service.
$DfltInstance.Refresh(); $DfltInstance
</pre></div>
            
        </div>
    </div>
</div>
</li>
  </ul>
  <p>
    
    <img id="UpArrow16x16" alt="用于“返回首页”链接的箭头图标" src="./启用或禁用服务器网络协议(Ch)_files/IC169559.gif" title="用于“返回首页”链接的箭头图标" xmlns="">
    <span>
      <a href="http://technet.microsoft.com/zh-cn/library/ms191294#Intro">[Top]</a>
    </span>
  </p>
</div></div>
      </div>
    </div>
  </div>
</div>

        



<div id="contentFeedback">
    <form method="post" action="http://technet.microsoft.com/zh-cn/library/feedback/add/ms191294">
        <input name="__RequestVerificationToken" type="hidden" value="7mOOQ5edFM7srpfI6xEiup427fmEoWbKkooSIm1rnKpwj1FlK8idEGWntwWFkpICHko12ppuw0KSU1JiXCgIDxOUgsWzid+USrGE3ZgZ8s9MSM2NbdJ2WZpshkKm1VXmH7G3Hg==">
    <div id="contentFeedbackContainer">
        <div class="FeedbackTitleContainer">
            <a name="feedback"></a>
        本文是否对您有所帮助？
            <input id="rdIsUsefulYes" name="rdIsUseful" type="radio" value="1" onclick="toggleContentFeedback(&#39;Yes&#39;);"><label for="rdIsUsefulYes">是</label>
            <input id="rdIsUsefulNo" name="rdIsUseful" type="radio" value="0" onclick="toggleContentFeedback(&#39;No&#39;);"><label for="rdIsUsefulNo">否</label>
        
        </div>
        
            <div id="contentFeedbackQAContainer">
                
                    <div id="feedbackListNoContainer" class="FeedbackListContainer">
                        
                            <div>
                                <input id="chkbxNo201" name="chkbxNo" type="checkbox" value="201">
                                <label for="chkbxNo201">不准确</label>
                            </div>
                        
                            <div>
                                <input id="chkbxNo202" name="chkbxNo" type="checkbox" value="202">
                                <label for="chkbxNo202">深度不够</label>
                            </div>
                        
                            <div>
                                <input id="chkbxNo203" name="chkbxNo" type="checkbox" value="203">
                                <label for="chkbxNo203">需要更多代码示例</label>
                            </div>
                        
                            <div>
                                <input id="chkbxNo204" name="chkbxNo" type="checkbox" value="204">
                                <label for="chkbxNo204">翻译需要改进</label>
                            </div>
                        
                    </div>
                
                <div class="FeedbackTellUsMoreContainer">
                    <textarea id="feedbackText" name="feedbackText" class="TellUsMoreTextBoxSearchLoaded" onfocus="WatermarkFocus(this, &#39;请告诉我们更多意见...&#39;, &#39;TellUsMoreTextBoxSearch&#39;)" onblur="WatermarkBlur(this, &#39;请告诉我们更多意见...&#39;, &#39;TellUsMoreTextBoxSearchLoaded&#39;)" onkeydown="TextBoxCharactersCounter(this, document.getElementById(&#39;feedbackTextCounter&#39;), 1500)" onkeyup="TextBoxCharactersCounter(this, document.getElementById(&#39;feedbackTextCounter&#39;), 1500)">请告诉我们更多意见...</textarea>
                </div>
                <span class="counter">(<span id="feedbackTextCounter">1500</span> 个剩余字符)</span>
                <input type="hidden" id="returnUrl" name="returnUrl" value="http://technet.microsoft.com/zh-cn/library/ms191294">
                <input type="submit" id="submit" value="提交" title="单击以提交反馈" onclick="WatermarkOnSubmit(document.getElementById(&#39;feedbackText&#39;), &#39;请告诉我们更多意见...&#39;, &#39;TellUsMoreTextBoxSearch&#39;)">
                <div style="clear: both;"></div>
            </div>  
        
    </div>
    </form>
</div>

    </div>
    
    <div class="topicEndLine">
    </div>
    <div id="CommunityContent" class="CommunityContent">
      
<div class="CommunityContentContainer">
    <div id="CommunityContentHeader" class="CommunityContentHeader">
      <div class="CommunityContentHeaderTitleContainer">
        <span class="CommunityContentHeaderTitle h1">社区内容</span>
          
        <a href="http://technet.microsoft.com/zh-cn/library/community/add/ms191294" title="添加" rel="nofollow">添加</a>
          
        </div>
        <div class="CommunityContentFaq">
            <a href="http://technet.microsoft.com/zh-cn/library/community-edits.rss?topic=ms191294|zh-cn|SQL.110" title="批注" rel="nofollow"><img class="cl_rss_button" alt="批注" src="./启用或禁用服务器网络协议(Ch)_files/clear.gif"></a>
            <a href="http://technet.microsoft.com/zh-cn/library/community-msdnwikifaq.aspx" title="常见问题" rel="nofollow">常见问题</a>
        </div>
        <div style="clear:both"></div>
    </div>
    
    

</div>
    </div>
    
  </div>
  
    </div>
    <div class="footer">
        

<div id="footer" class="technet footerContainer cl_footer_slice">
  <div class="footerLogoContainer">
    <div class="footerContent">
    <div class="copyright">
      © 2012 Microsoft. 版权所有。 </div>
    <div class="footerLogo cl_footer_logo"></div>
    <a href="http://technet.microsoft.com/zh-cn/cc300389">保留所有权利</a><span class="pipe"> | </span>
    <a href="http://www.microsoft.com/library/toolbar/3.0/trademarks/zh-cn.mspx">商标</a><span class="pipe"> | </span>
    <a href="http://www.microsoft.com/info/cn/privacy.mspx">隐私权声明</a>
    <span class="pipe">| </span>
    <a href="http://go.microsoft.com/?linkid=8786243&lcid=2052">个人信息中心</a><span class="pipe"> | </span>
    <a href="http://www.microsoft.com/china/technet/feedback/">联系我们</a><span class="pipe"> | </span>
    <a href="http://www.microsoft.com/china/technet/newsletter/">中文速递邮件</a>
    <span class="pipe">| </span>
    <span class="FeedbacklinkDisabled" id="FeedbacklinkDisabled">网站反馈</span>
    <a id="Feedbacklink" title="网站反馈" class="FeedbackLink" href="javascript:void(0)">
      网站反馈
        <span class="FeedbackButton clip20x21" id="FeedbackButton">
          <img id="feedBackImg" class="cl_footer_feedback_icon" src="./启用或禁用服务器网络协议(Ch)_files/LibrarySprite.png" alt="网站反馈">
        </span>
      </a>
    
  <div id="FeedbackContainer" class="FeedbackContainer">
    <form id="siteFeedbackForm" method="post" action="http://technet.microsoft.com/zh-cn/library/feedback/add/ms191294">
        <input name="__RequestVerificationToken" type="hidden" value="tpamxlrXqVURJZH7N32ZvdfBfAwIwujBnDlWDiyUaFT0fEgAqS5OD+vu1YGShYALbf/WEMvke1EPIslB6BfwqmpzpqopTWAIWwCY3E1VPY7bdo9npoN/HXT+OE3JaHV6hoJr0A==">
    <div class="FeedbackTitleContainer">
        <div class="FeedbackTitle">
            网站反馈</div>
        <div class="FeedbackCancel">
            <a href="javascript:;" onclick="document.getElementById(&#39;FeedbackContainer&#39;).style.display = &#39;none&#39;;">x</a>
            </div>
    </div>
    <div class="FeedbackData">
        <div class="FeedbackInfoText">
            请与我们分享您的经历…
        </div>
        <div class="QuestionText">
            页面加载速度够快吗？
        </div>
        <div class="AnswerText">
            
            <span>
                是<span>
                    <input id="searchBox" name="searchBox" type="radio" value="1"></span></span>
            
            <span>
                否<span>
                    <input id="searchBox" name="searchBox" type="radio" value="0"></span></span>
            
        </div>
        <div class="QuestionText">
            您喜欢网页的设计吗？
        </div>
        <div class="AnswerText">
            
            <span>
                是<span>
                    <input id="tabbedCode" name="tabbedCode" type="radio" value="1"></span></span>
            
            <span>
                否<span>
                    <input id="tabbedCode" name="tabbedCode" type="radio" value="0"></span></span>
            
        </div>
        <div class="QuestionText">
            请告诉我们更多意见
        </div>
        <div class="FeedbackTextAreaContainer">
            <textarea id="feedbackText" data-maxlength="4000" name="feedbackText" cols="25" rows="5" class="FeedbackTextArea"></textarea>
            
            <textarea id="feedbackDescription" name="feedbackDescription" cols="25" rows="10" style="display:none;">Enter description here.</textarea>
            <input type="hidden" id="feedbackPriority" name="feedbackPriority" value="">
            <input type="hidden" id="feedbackSourceUrl" name="feedbackSourceUrl" value="">
            <input type="hidden" id="ClientIP" name="ClientIP" value="">
            <input type="hidden" id="ClientOS" name="ClientOS" value="">
            <input type="hidden" id="ClientBrowser" name="ClientBrowser" value="">
            <input type="hidden" id="ClientTime" name="ClientTime" value="">
            <input type="hidden" id="ClientTimeZone" name="ClientTimeZone" value="">
            
            
        </div>
        <div>
            <input id="siteFeedbackSubmit" type="submit" value="发送" class="FeedbackSubmit" onclick="submitSiteFeedback(&#39;-1&#39;);">
        </div>
    </div>
    <input type="hidden" id="returnUrl" name="returnUrl" value="http://technet.microsoft.com/zh-cn/library/ms191294">
    
    
    <input type="hidden" id="feedBackVersion" name="feedBackVersion" value="1">
    
  </form> 
</div>

    </div>
  </div>
</div>

    </div>
    
    
<!--[CDATA[ Third party scripts and code linked to or referenced from this website are licensed to you by the parties that own such code, not by Microsoft.  See ASP.NET Ajax CDN Terms of Use – http://www.asp.net/ajaxlibrary/CDN.ashx. ]]-->
        <div class="MetricsContainer">
            
    <div class="WebtrendsContainer">
      

<script type="text/javascript">
//<![CDATA[
  var literalNormalizedUrl = '/zh-cn/library/ms191294(d=lightweight,l=zh-cn,v=sql.110).aspx';
  var wt_nvr_ru = 'WT_NVR_RU';
  var wt_fpcdom = '.microsoft.com';
  var wt_domlist = 'technet.microsoft.com';
  var wt_pathlist = '/technet/';
  var wt_paramlist = 'DCSext.mtps_techcenter';
  var wt_siteid = 'TECHNET';
  var gDomain = 'm.webtrends.com';
  var gDcsId = 'dcsjwb9vb00000c932fd0rjc7_5p3t';
  var gFpc = 'WT_FPC';
  if (document.cookie.indexOf(gFpc + "=") == -1) {
    var wtidJs = document.createElement("script");
    wtidJs.src = "//" + gDomain + "/" + gDcsId + "/wtid.js";
    document.getElementsByTagName("head")[0].appendChild(wtidJs);
  }
  var detectedLocale = 'zh-cn';
  var wtsp = '_technet_library_sqlserver_';
  var gTrackEvents = '0';
/*]]>*/
</script>
<noscript>&lt;div&gt;&lt;img alt="DCSIMG" id="Img1" width="1" height="1" src="http://m.webtrends.com/dcsjwb9vb00000c932fd0rjc7_5p3t/njs.gif?dcsuri=/nojavascript&amp;amp;WT.js=No" /&gt;&lt;/div&gt;</noscript>


    </div>
    
    <div class="OmnitureContainer">
      



<script type="text/javascript">
  var omni_guid = '002f01d7-0ad9-4819-8815-2b152d6bc6da'; 
</script>



<noscript>
    &lt;a href="http://www.omniture.com" title="Web Analytics"&gt;
        &lt;img src="//msstonojstechnet.112.2o7.net/b/ss/msstonojstechnet/1/H.20.2--NS/0" height="1" width="1" border="0" alt="" /&gt;&lt;/a&gt;
</noscript>


    </div>
    
        </div>
        
        
             
        
<script type="text/javascript">
    //<![CDATA[
    var brokerJs = document.createElement("script");
    brokerJs.src = "//js.microsoft.com/library/svy/sto/broker.js";
    document.getElementsByTagName("head")[0].appendChild(brokerJs);
    /*]]>*/
</script>

<script type="text/javascript" src="./启用或禁用服务器网络协议(Ch)_files/Combined.js" xmlns="http://www.w3.org/1999/xhtml"></script>
<div id="popup-loading0" class="popup-loading" style="display: none; z-index: 97; width: auto; height: auto; left: 69px; top: 620px; ">loading...</div><div id="popup0" class="MTPopup" style="z-index: 97; width: auto; height: auto; max-width: 712px; left: 69px; top: 620px; display: block; "><div class="popup-main" style="z-index: 97; "><div class="popup-inner">In the details pane, right-click <span class="label">SQL Server (</span><span class="parameter">&lt;instance name&gt;</span><span class="label">)</span>, and then click <span class="label">Restart</span>, to stop and restart the SQL Server service.</div></div></div><script src="./启用或禁用服务器网络协议(Ch)_files/broker-config.js"></script><div style="display: none; " id="_WEDCSInsertedData"><iframe id="_msnFrame" src="./启用或禁用服务器网络协议(Ch)_files/Sync.htm" style="z-index:-1;height:1px;width:1px;display:none;visibility:hidden;" onload="javascript:MscomBeacon();"></iframe></div></body></html>